Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 4328 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 507.2 KiB |
| Average record size in memory | 120.0 B |
Variable types
| Numeric | 14 |
|---|
monetary is highly overall correlated with unique_prods and 6 other fields | High correlation |
unique_prods is highly overall correlated with monetary and 4 other fields | High correlation |
qt_prods is highly overall correlated with monetary and 7 other fields | High correlation |
avg_basket_size is highly overall correlated with unique_prods and 1 other fields | High correlation |
recency is highly overall correlated with qt_prods and 2 other fields | High correlation |
relationship_duration is highly overall correlated with monetary and 6 other fields | High correlation |
purchase_count is highly overall correlated with monetary and 6 other fields | High correlation |
returns_count is highly overall correlated with return_rate | High correlation |
return_rate is highly overall correlated with returns_count | High correlation |
avg_purchase_interval is highly overall correlated with monetary and 4 other fields | High correlation |
frequency is highly overall correlated with monetary and 4 other fields | High correlation |
avg_order_value is highly overall correlated with monetary | High correlation |
monetary is highly skewed (γ1 = 21.5227491) | Skewed |
returns_count is highly skewed (γ1 = 26.4818313) | Skewed |
avg_unit_price is highly skewed (γ1 = 36.53614951) | Skewed |
return_rate is highly skewed (γ1 = 40.70929296) | Skewed |
avg_purchase_interval is highly skewed (γ1 = 59.06472112) | Skewed |
frequency is highly skewed (γ1 = 59.06472112) | Skewed |
customer_id has unique values | Unique |
relationship_duration has 1555 (35.9%) zeros | Zeros |
returns_count has 2825 (65.3%) zeros | Zeros |
return_rate has 2825 (65.3%) zeros | Zeros |
avg_purchase_interval has 1555 (35.9%) zeros | Zeros |
frequency has 1555 (35.9%) zeros | Zeros |
Reproduction
| Analysis started | 2023-06-25 22:51:24.227513 |
|---|---|
| Analysis finished | 2023-06-25 22:51:52.339963 |
| Duration | 28.11 seconds |
| Software version | ydata-profiling vv4.2.0 |
| Download configuration | config.json |
customer_id
Real number (ℝ)
| Distinct | 4328 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15301.107 |
| Minimum | 12347 |
|---|---|
| Maximum | 18287 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 12347 |
|---|---|
| 5-th percentile | 12616.35 |
| Q1 | 13813.75 |
| median | 15299.5 |
| Q3 | 16780.25 |
| 95-th percentile | 17984.65 |
| Maximum | 18287 |
| Range | 5940 |
| Interquartile range (IQR) | 2966.5 |
Descriptive statistics
| Standard deviation | 1721.3706 |
|---|---|
| Coefficient of variation (CV) | 0.11249975 |
| Kurtosis | -1.1957468 |
| Mean | 15301.107 |
| Median Absolute Deviation (MAD) | 1484 |
| Skewness | 0.0019049645 |
| Sum | 66223189 |
| Variance | 2963116.8 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 12347 | 1 | < 0.1% |
| 16297 | 1 | < 0.1% |
| 16272 | 1 | < 0.1% |
| 16274 | 1 | < 0.1% |
| 16275 | 1 | < 0.1% |
| 16276 | 1 | < 0.1% |
| 16278 | 1 | < 0.1% |
| 16279 | 1 | < 0.1% |
| 16281 | 1 | < 0.1% |
| 16282 | 1 | < 0.1% |
| Other values (4318) | 4318 |
| Value | Count | Frequency (%) |
| 12347 | 1 | |
| 12348 | 1 | |
| 12349 | 1 | |
| 12350 | 1 | |
| 12352 | 1 | |
| 12353 | 1 | |
| 12354 | 1 | |
| 12355 | 1 | |
| 12356 | 1 | |
| 12357 | 1 |
| Value | Count | Frequency (%) |
| 18287 | 1 | |
| 18283 | 1 | |
| 18282 | 1 | |
| 18281 | 1 | |
| 18280 | 1 | |
| 18278 | 1 | |
| 18277 | 1 | |
| 18276 | 1 | |
| 18274 | 1 | |
| 18273 | 1 |
monetary
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 4245 |
|---|---|
| Distinct (%) | 98.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1916.1357 |
| Minimum | -796.86 |
|---|---|
| Maximum | 278778.02 |
| Zeros | 9 |
| Zeros (%) | 0.2% |
| Negative | 3 |
| Negative (%) | 0.1% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | -796.86 |
|---|---|
| 5-th percentile | 109.0325 |
| Q1 | 298.92 |
| median | 652.81 |
| Q3 | 1610.2275 |
| 95-th percentile | 5650.59 |
| Maximum | 278778.02 |
| Range | 279574.88 |
| Interquartile range (IQR) | 1311.3075 |
Descriptive statistics
| Standard deviation | 8313.9946 |
|---|---|
| Coefficient of variation (CV) | 4.3389382 |
| Kurtosis | 596.66174 |
| Mean | 1916.1357 |
| Median Absolute Deviation (MAD) | 453.98 |
| Skewness | 21.522749 |
| Sum | 8293035.5 |
| Variance | 69122507 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 9 | 0.2% |
| 76.32 | 4 | 0.1% |
| 440 | 3 | 0.1% |
| 113.5 | 3 | 0.1% |
| 15 | 3 | 0.1% |
| 363.65 | 3 | 0.1% |
| 35.4 | 3 | 0.1% |
| 238.85 | 2 | < 0.1% |
| 326.4 | 2 | < 0.1% |
| 204 | 2 | < 0.1% |
| Other values (4235) | 4294 |
| Value | Count | Frequency (%) |
| -796.86 | 1 | < 0.1% |
| -141.48 | 1 | < 0.1% |
| -95.93 | 1 | < 0.1% |
| 0 | 9 | |
| 5.684341886 × 10-14 | 1 | < 0.1% |
| 4.547473509 × 10-13 | 1 | < 0.1% |
| 3.75 | 1 | < 0.1% |
| 5.9 | 1 | < 0.1% |
| 12.24 | 1 | < 0.1% |
| 12.75 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 278778.02 | 1 | |
| 259657.3 | 1 | |
| 189735.53 | 1 | |
| 133007.13 | 1 | |
| 123638.18 | 1 | |
| 114505.32 | 1 | |
| 88138.2 | 1 | |
| 65920.12 | 1 | |
| 62924.1 | 1 | |
| 59419.34 | 1 |
unique_prods
Real number (ℝ)
| Distinct | 341 |
|---|---|
| Distinct (%) | 7.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 61.456331 |
| Minimum | 1 |
|---|---|
| Maximum | 1786 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 16 |
| median | 35 |
| Q3 | 77 |
| 95-th percentile | 204 |
| Maximum | 1786 |
| Range | 1785 |
| Interquartile range (IQR) | 61 |
Descriptive statistics
| Standard deviation | 85.364548 |
|---|---|
| Coefficient of variation (CV) | 1.3890277 |
| Kurtosis | 99.651934 |
| Mean | 61.456331 |
| Median Absolute Deviation (MAD) | 24 |
| Skewness | 6.917132 |
| Sum | 265983 |
| Variance | 7287.106 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 93 | 2.1% |
| 10 | 86 | 2.0% |
| 8 | 80 | 1.8% |
| 9 | 79 | 1.8% |
| 11 | 78 | 1.8% |
| 13 | 76 | 1.8% |
| 5 | 73 | 1.7% |
| 15 | 73 | 1.7% |
| 6 | 73 | 1.7% |
| 14 | 72 | 1.7% |
| Other values (331) | 3545 |
| Value | Count | Frequency (%) |
| 1 | 93 | |
| 2 | 52 | |
| 3 | 60 | |
| 4 | 52 | |
| 5 | 73 | |
| 6 | 73 | |
| 7 | 72 | |
| 8 | 80 | |
| 9 | 79 | |
| 10 | 86 |
| Value | Count | Frequency (%) |
| 1786 | 1 | |
| 1766 | 1 | |
| 1322 | 1 | |
| 1118 | 1 | |
| 884 | 1 | |
| 817 | 1 | |
| 717 | 1 | |
| 714 | 1 | |
| 699 | 1 | |
| 636 | 1 |
qt_prods
Real number (ℝ)
| Distinct | 468 |
|---|---|
| Distinct (%) | 10.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 91.537893 |
| Minimum | 1 |
|---|---|
| Maximum | 7838 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 17 |
| median | 41 |
| Q3 | 100 |
| 95-th percentile | 314.65 |
| Maximum | 7838 |
| Range | 7837 |
| Interquartile range (IQR) | 83 |
Descriptive statistics
| Standard deviation | 228.63639 |
|---|---|
| Coefficient of variation (CV) | 2.4977239 |
| Kurtosis | 483.13585 |
| Mean | 91.537893 |
| Median Absolute Deviation (MAD) | 30 |
| Skewness | 18.102096 |
| Sum | 396176 |
| Variance | 52274.597 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 86 | 2.0% |
| 6 | 78 | 1.8% |
| 9 | 75 | 1.7% |
| 1 | 72 | 1.7% |
| 11 | 70 | 1.6% |
| 15 | 70 | 1.6% |
| 8 | 67 | 1.5% |
| 5 | 67 | 1.5% |
| 7 | 66 | 1.5% |
| 28 | 65 | 1.5% |
| Other values (458) | 3612 |
| Value | Count | Frequency (%) |
| 1 | 72 | |
| 2 | 51 | |
| 3 | 56 | |
| 4 | 48 | |
| 5 | 67 | |
| 6 | 78 | |
| 7 | 66 | |
| 8 | 67 | |
| 9 | 75 | |
| 10 | 86 |
| Value | Count | Frequency (%) |
| 7838 | 1 | |
| 5673 | 1 | |
| 5095 | 1 | |
| 4580 | 1 | |
| 2698 | 1 | |
| 2379 | 1 | |
| 2060 | 1 | |
| 1818 | 1 | |
| 1673 | 1 | |
| 1637 | 1 |
avg_basket_size
Real number (ℝ)
| Distinct | 1029 |
|---|---|
| Distinct (%) | 23.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.291473 |
| Minimum | 1 |
|---|---|
| Maximum | 299.70588 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2.8633929 |
| Q1 | 9.4214286 |
| median | 17 |
| Q3 | 28.4 |
| 95-th percentile | 59.666667 |
| Maximum | 299.70588 |
| Range | 298.70588 |
| Interquartile range (IQR) | 18.978571 |
Descriptive statistics
| Standard deviation | 20.660891 |
|---|---|
| Coefficient of variation (CV) | 0.92685175 |
| Kurtosis | 21.194047 |
| Mean | 22.291473 |
| Median Absolute Deviation (MAD) | 8.6666667 |
| Skewness | 3.2234831 |
| Sum | 96477.495 |
| Variance | 426.87241 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 99 | 2.3% |
| 13 | 93 | 2.1% |
| 10 | 88 | 2.0% |
| 9 | 82 | 1.9% |
| 11 | 78 | 1.8% |
| 14 | 77 | 1.8% |
| 6 | 74 | 1.7% |
| 7 | 72 | 1.7% |
| 5 | 70 | 1.6% |
| 8 | 69 | 1.6% |
| Other values (1019) | 3526 |
| Value | Count | Frequency (%) |
| 1 | 99 | |
| 1.2 | 1 | < 0.1% |
| 1.25 | 1 | < 0.1% |
| 1.333333333 | 2 | < 0.1% |
| 1.5 | 7 | 0.2% |
| 1.568181818 | 1 | < 0.1% |
| 1.571428571 | 1 | < 0.1% |
| 1.666666667 | 4 | 0.1% |
| 1.833333333 | 1 | < 0.1% |
| 2 | 62 |
| Value | Count | Frequency (%) |
| 299.7058824 | 1 | |
| 259 | 1 | |
| 219 | 1 | |
| 203.5 | 1 | |
| 191 | 1 | |
| 171 | 1 | |
| 164 | 1 | |
| 157 | 2 | |
| 153 | 1 | |
| 148 | 1 |
recency
Real number (ℝ)
| Distinct | 304 |
|---|---|
| Distinct (%) | 7.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 92.152957 |
| Minimum | 0 |
|---|---|
| Maximum | 373 |
| Zeros | 34 |
| Zeros (%) | 0.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 17 |
| median | 50 |
| Q3 | 142 |
| 95-th percentile | 311 |
| Maximum | 373 |
| Range | 373 |
| Interquartile range (IQR) | 125 |
Descriptive statistics
| Standard deviation | 100.20037 |
|---|---|
| Coefficient of variation (CV) | 1.0873266 |
| Kurtosis | 0.42457035 |
| Mean | 92.152957 |
| Median Absolute Deviation (MAD) | 40 |
| Skewness | 1.245256 |
| Sum | 398838 |
| Variance | 10040.113 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 103 | 2.4% |
| 3 | 94 | 2.2% |
| 4 | 94 | 2.2% |
| 2 | 90 | 2.1% |
| 8 | 79 | 1.8% |
| 10 | 77 | 1.8% |
| 17 | 74 | 1.7% |
| 7 | 72 | 1.7% |
| 9 | 70 | 1.6% |
| 22 | 64 | 1.5% |
| Other values (294) | 3511 |
| Value | Count | Frequency (%) |
| 0 | 34 | 0.8% |
| 1 | 103 | |
| 2 | 90 | |
| 3 | 94 | |
| 4 | 94 | |
| 5 | 48 | |
| 7 | 72 | |
| 8 | 79 | |
| 9 | 70 | |
| 10 | 77 |
| Value | Count | Frequency (%) |
| 373 | 17 | |
| 372 | 18 | |
| 371 | 6 | 0.1% |
| 369 | 3 | 0.1% |
| 368 | 5 | 0.1% |
| 367 | 5 | 0.1% |
| 366 | 10 | |
| 365 | 10 | |
| 364 | 6 | 0.1% |
| 362 | 6 | 0.1% |
relationship_duration
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 374 |
|---|---|
| Distinct (%) | 8.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 130.73082 |
| Minimum | 0 |
|---|---|
| Maximum | 373 |
| Zeros | 1555 |
| Zeros (%) | 35.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 93 |
| Q3 | 252 |
| 95-th percentile | 357 |
| Maximum | 373 |
| Range | 373 |
| Interquartile range (IQR) | 252 |
Descriptive statistics
| Standard deviation | 132.31843 |
|---|---|
| Coefficient of variation (CV) | 1.0121441 |
| Kurtosis | -1.3313579 |
| Mean | 130.73082 |
| Median Absolute Deviation (MAD) | 93 |
| Skewness | 0.4528219 |
| Sum | 565803 |
| Variance | 17508.168 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1555 | |
| 364 | 28 | 0.6% |
| 350 | 26 | 0.6% |
| 357 | 25 | 0.6% |
| 366 | 20 | 0.5% |
| 351 | 20 | 0.5% |
| 355 | 19 | 0.4% |
| 365 | 18 | 0.4% |
| 343 | 18 | 0.4% |
| 356 | 17 | 0.4% |
| Other values (364) | 2582 |
| Value | Count | Frequency (%) |
| 0 | 1555 | |
| 1 | 9 | 0.2% |
| 2 | 4 | 0.1% |
| 3 | 5 | 0.1% |
| 4 | 4 | 0.1% |
| 5 | 3 | 0.1% |
| 6 | 2 | < 0.1% |
| 7 | 7 | 0.2% |
| 8 | 5 | 0.1% |
| 9 | 3 | 0.1% |
| Value | Count | Frequency (%) |
| 373 | 5 | 0.1% |
| 372 | 8 | 0.2% |
| 371 | 8 | 0.2% |
| 370 | 8 | 0.2% |
| 369 | 6 | 0.1% |
| 368 | 10 | 0.2% |
| 367 | 11 | 0.3% |
| 366 | 20 | |
| 365 | 18 | |
| 364 | 28 |
purchase_count
Real number (ℝ)
| Distinct | 56 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.2518484 |
| Minimum | 1 |
|---|---|
| Maximum | 206 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 5 |
| 95-th percentile | 13 |
| Maximum | 206 |
| Range | 205 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 7.6516406 |
|---|---|
| Coefficient of variation (CV) | 1.7996033 |
| Kurtosis | 244.52051 |
| Mean | 4.2518484 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 11.961503 |
| Sum | 18402 |
| Variance | 58.547605 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1504 | |
| 2 | 825 | |
| 3 | 503 | 11.6% |
| 4 | 394 | 9.1% |
| 5 | 237 | 5.5% |
| 6 | 173 | 4.0% |
| 7 | 138 | 3.2% |
| 8 | 98 | 2.3% |
| 9 | 69 | 1.6% |
| 10 | 55 | 1.3% |
| Other values (46) | 332 | 7.7% |
| Value | Count | Frequency (%) |
| 1 | 1504 | |
| 2 | 825 | |
| 3 | 503 | 11.6% |
| 4 | 394 | 9.1% |
| 5 | 237 | 5.5% |
| 6 | 173 | 4.0% |
| 7 | 138 | 3.2% |
| 8 | 98 | 2.3% |
| 9 | 69 | 1.6% |
| 10 | 55 | 1.3% |
| Value | Count | Frequency (%) |
| 206 | 1 | |
| 199 | 1 | |
| 124 | 1 | |
| 97 | 1 | |
| 91 | 2 | |
| 86 | 1 | |
| 72 | 1 | |
| 62 | 2 | |
| 60 | 1 | |
| 57 | 1 |
returns_count
Real number (ℝ)
HIGH CORRELATION  SKEWED  ZEROS 
| Distinct | 213 |
|---|---|
| Distinct (%) | 4.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.996765 |
| Minimum | 0 |
|---|---|
| Maximum | 9014 |
| Zeros | 2825 |
| Zeros (%) | 65.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 3 |
| 95-th percentile | 58.65 |
| Maximum | 9014 |
| Range | 9014 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 234.78991 |
|---|---|
| Coefficient of variation (CV) | 9.7842316 |
| Kurtosis | 866.92703 |
| Mean | 23.996765 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 26.481831 |
| Sum | 103858 |
| Variance | 55126.301 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2825 | |
| 1 | 169 | 3.9% |
| 2 | 150 | 3.5% |
| 3 | 105 | 2.4% |
| 4 | 89 | 2.1% |
| 6 | 78 | 1.8% |
| 5 | 61 | 1.4% |
| 12 | 52 | 1.2% |
| 7 | 44 | 1.0% |
| 8 | 43 | 1.0% |
| Other values (203) | 712 | 16.5% |
| Value | Count | Frequency (%) |
| 0 | 2825 | |
| 1 | 169 | 3.9% |
| 2 | 150 | 3.5% |
| 3 | 105 | 2.4% |
| 4 | 89 | 2.1% |
| 5 | 61 | 1.4% |
| 6 | 78 | 1.8% |
| 7 | 44 | 1.0% |
| 8 | 43 | 1.0% |
| 9 | 41 | 0.9% |
| Value | Count | Frequency (%) |
| 9014 | 1 | |
| 8004 | 1 | |
| 4427 | 1 | |
| 3768 | 1 | |
| 3332 | 1 | |
| 2878 | 1 | |
| 2022 | 1 | |
| 2012 | 1 | |
| 1776 | 1 | |
| 1594 | 1 |
avg_unit_price
Real number (ℝ)
| Distinct | 4176 |
|---|---|
| Distinct (%) | 96.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.4664777 |
| Minimum | 0.1225 |
|---|---|
| Maximum | 434.65 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0.1225 |
|---|---|
| 5-th percentile | 1.3180392 |
| Q1 | 2.155125 |
| median | 2.8285824 |
| Q3 | 3.7120688 |
| 95-th percentile | 5.984999 |
| Maximum | 434.65 |
| Range | 434.5275 |
| Interquartile range (IQR) | 1.5569438 |
Descriptive statistics
| Standard deviation | 8.8708451 |
|---|---|
| Coefficient of variation (CV) | 2.5590371 |
| Kurtosis | 1579.0521 |
| Mean | 3.4664777 |
| Median Absolute Deviation (MAD) | 0.74715195 |
| Skewness | 36.53615 |
| Sum | 15002.916 |
| Variance | 78.691892 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.06 | 10 | 0.2% |
| 1.79 | 8 | 0.2% |
| 2.08 | 7 | 0.2% |
| 4.95 | 7 | 0.2% |
| 1.25 | 7 | 0.2% |
| 2.95 | 6 | 0.1% |
| 2.55 | 6 | 0.1% |
| 12.75 | 5 | 0.1% |
| 4.25 | 4 | 0.1% |
| 0.72 | 4 | 0.1% |
| Other values (4166) | 4264 |
| Value | Count | Frequency (%) |
| 0.1225 | 1 | |
| 0.17 | 2 | |
| 0.2327777778 | 1 | |
| 0.29 | 2 | |
| 0.32 | 1 | |
| 0.358 | 1 | |
| 0.3666666667 | 1 | |
| 0.39 | 1 | |
| 0.3917241379 | 1 | |
| 0.39375 | 1 |
| Value | Count | Frequency (%) |
| 434.65 | 1 | |
| 295 | 1 | |
| 125 | 1 | |
| 110 | 2 | |
| 74.975 | 1 | |
| 66.475 | 1 | |
| 59.73333333 | 1 | |
| 54.3 | 1 | |
| 51.71 | 1 | |
| 32.97142857 | 1 |
return_rate
Real number (ℝ)
HIGH CORRELATION  SKEWED  ZEROS 
| Distinct | 471 |
|---|---|
| Distinct (%) | 10.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.6878971 |
| Minimum | 0 |
|---|---|
| Maximum | 3004.6667 |
| Zeros | 2825 |
| Zeros (%) | 65.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 11.2 |
| Maximum | 3004.6667 |
| Range | 3004.6667 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 55.660421 |
|---|---|
| Coefficient of variation (CV) | 11.873217 |
| Kurtosis | 2032.7264 |
| Mean | 4.6878971 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 40.709293 |
| Sum | 20289.219 |
| Variance | 3098.0825 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2825 | |
| 1 | 112 | 2.6% |
| 2 | 81 | 1.9% |
| 0.5 | 64 | 1.5% |
| 3 | 52 | 1.2% |
| 0.3333333333 | 43 | 1.0% |
| 4 | 40 | 0.9% |
| 1.5 | 33 | 0.8% |
| 6 | 32 | 0.7% |
| 0.25 | 29 | 0.7% |
| Other values (461) | 1017 | 23.5% |
| Value | Count | Frequency (%) |
| 0 | 2825 | |
| 0.03571428571 | 1 | < 0.1% |
| 0.04761904762 | 1 | < 0.1% |
| 0.05 | 1 | < 0.1% |
| 0.05555555556 | 1 | < 0.1% |
| 0.07272727273 | 1 | < 0.1% |
| 0.07692307692 | 1 | < 0.1% |
| 0.08333333333 | 1 | < 0.1% |
| 0.09090909091 | 2 | < 0.1% |
| 0.1 | 6 | 0.1% |
| Value | Count | Frequency (%) |
| 3004.666667 | 1 | |
| 1228 | 1 | |
| 1006 | 1 | |
| 510 | 1 | |
| 426 | 1 | |
| 378.75 | 1 | |
| 336 | 1 | |
| 314 | 1 | |
| 312 | 1 | |
| 300 | 1 |
avg_purchase_interval
Real number (ℝ)
HIGH CORRELATION  SKEWED  ZEROS 
| Distinct | 1229 |
|---|---|
| Distinct (%) | 28.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.03962258 |
| Minimum | 0 |
|---|---|
| Maximum | 34 |
| Zeros | 1555 |
| Zeros (%) | 35.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.014925373 |
| Q3 | 0.03030303 |
| 95-th percentile | 0.089146825 |
| Maximum | 34 |
| Range | 34 |
| Interquartile range (IQR) | 0.03030303 |
Descriptive statistics
| Standard deviation | 0.53673128 |
|---|---|
| Coefficient of variation (CV) | 13.546096 |
| Kurtosis | 3710.6697 |
| Mean | 0.03962258 |
| Median Absolute Deviation (MAD) | 0.014925373 |
| Skewness | 59.064721 |
| Sum | 171.48653 |
| Variance | 0.28808046 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1555 | |
| 0.07142857143 | 16 | 0.4% |
| 0.04761904762 | 15 | 0.3% |
| 0.02857142857 | 14 | 0.3% |
| 0.0303030303 | 14 | 0.3% |
| 0.01587301587 | 14 | 0.3% |
| 0.06451612903 | 13 | 0.3% |
| 0.02380952381 | 13 | 0.3% |
| 0.1428571429 | 13 | 0.3% |
| 0.025 | 12 | 0.3% |
| Other values (1219) | 2649 |
| Value | Count | Frequency (%) |
| 0 | 1555 | |
| 0.005464480874 | 1 | < 0.1% |
| 0.005479452055 | 1 | < 0.1% |
| 0.005494505495 | 1 | < 0.1% |
| 0.005509641873 | 1 | < 0.1% |
| 0.005602240896 | 2 | < 0.1% |
| 0.005617977528 | 1 | < 0.1% |
| 0.005633802817 | 2 | < 0.1% |
| 0.005681818182 | 1 | < 0.1% |
| 0.005698005698 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 34 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
| 2 | 6 | |
| 1.5 | 1 | < 0.1% |
| 1.333333333 | 2 | < 0.1% |
| 1 | 4 | |
| 0.6666666667 | 3 | |
| 0.5522788204 | 1 | < 0.1% |
| 0.5349462366 | 1 | < 0.1% |
frequency
Real number (ℝ)
HIGH CORRELATION  SKEWED  ZEROS 
| Distinct | 1229 |
|---|---|
| Distinct (%) | 28.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.03962258 |
| Minimum | 0 |
|---|---|
| Maximum | 34 |
| Zeros | 1555 |
| Zeros (%) | 35.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.014925373 |
| Q3 | 0.03030303 |
| 95-th percentile | 0.089146825 |
| Maximum | 34 |
| Range | 34 |
| Interquartile range (IQR) | 0.03030303 |
Descriptive statistics
| Standard deviation | 0.53673128 |
|---|---|
| Coefficient of variation (CV) | 13.546096 |
| Kurtosis | 3710.6697 |
| Mean | 0.03962258 |
| Median Absolute Deviation (MAD) | 0.014925373 |
| Skewness | 59.064721 |
| Sum | 171.48653 |
| Variance | 0.28808046 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1555 | |
| 0.07142857143 | 16 | 0.4% |
| 0.04761904762 | 15 | 0.3% |
| 0.02857142857 | 14 | 0.3% |
| 0.0303030303 | 14 | 0.3% |
| 0.01587301587 | 14 | 0.3% |
| 0.06451612903 | 13 | 0.3% |
| 0.02380952381 | 13 | 0.3% |
| 0.1428571429 | 13 | 0.3% |
| 0.025 | 12 | 0.3% |
| Other values (1219) | 2649 |
| Value | Count | Frequency (%) |
| 0 | 1555 | |
| 0.005464480874 | 1 | < 0.1% |
| 0.005479452055 | 1 | < 0.1% |
| 0.005494505495 | 1 | < 0.1% |
| 0.005509641873 | 1 | < 0.1% |
| 0.005602240896 | 2 | < 0.1% |
| 0.005617977528 | 1 | < 0.1% |
| 0.005633802817 | 2 | < 0.1% |
| 0.005681818182 | 1 | < 0.1% |
| 0.005698005698 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 34 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
| 2 | 6 | |
| 1.5 | 1 | < 0.1% |
| 1.333333333 | 2 | < 0.1% |
| 1 | 4 | |
| 0.6666666667 | 3 | |
| 0.5522788204 | 1 | < 0.1% |
| 0.5349462366 | 1 | < 0.1% |
avg_order_value
Real number (ℝ)
| Distinct | 4241 |
|---|---|
| Distinct (%) | 98.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 369.72062 |
| Minimum | -796.86 |
|---|---|
| Maximum | 13206.5 |
| Zeros | 9 |
| Zeros (%) | 0.2% |
| Negative | 3 |
| Negative (%) | 0.1% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | -796.86 |
|---|---|
| 5-th percentile | 85.013125 |
| Q1 | 173.8975 |
| median | 282.301 |
| Q3 | 420.7745 |
| 95-th percentile | 890.82462 |
| Maximum | 13206.5 |
| Range | 14003.36 |
| Interquartile range (IQR) | 246.877 |
Descriptive statistics
| Standard deviation | 465.27961 |
|---|---|
| Coefficient of variation (CV) | 1.2584627 |
| Kurtosis | 201.77649 |
| Mean | 369.72062 |
| Median Absolute Deviation (MAD) | 118.065 |
| Skewness | 10.60863 |
| Sum | 1600150.8 |
| Variance | 216485.11 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 9 | 0.2% |
| 76.32 | 4 | 0.1% |
| 120 | 3 | 0.1% |
| 113.5 | 3 | 0.1% |
| 35.4 | 3 | 0.1% |
| 440 | 3 | 0.1% |
| 326.4 | 2 | < 0.1% |
| 436.005 | 2 | < 0.1% |
| 358 | 2 | < 0.1% |
| 72 | 2 | < 0.1% |
| Other values (4231) | 4295 |
| Value | Count | Frequency (%) |
| -796.86 | 1 | < 0.1% |
| -141.48 | 1 | < 0.1% |
| -47.965 | 1 | < 0.1% |
| 0 | 9 | |
| 5.684341886 × 10-14 | 1 | < 0.1% |
| 4.547473509 × 10-13 | 1 | < 0.1% |
| 3.75 | 1 | < 0.1% |
| 5.9 | 1 | < 0.1% |
| 7.5 | 1 | < 0.1% |
| 9.14 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 13206.5 | 1 | |
| 9338.38 | 1 | |
| 7178.633333 | 1 | |
| 6207.67 | 1 | |
| 6181.909 | 1 | |
| 4873.81 | 1 | |
| 4366.78 | 1 | |
| 4327.621667 | 1 | |
| 4314.72 | 1 | |
| 4151.26 | 1 |
| customer_id | monetary | unique_prods | qt_prods | avg_basket_size | recency | relationship_duration | purchase_count | returns_count | avg_unit_price | return_rate | avg_purchase_interval | frequency | avg_order_value | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| customer_id | 1.000 | -0.078 | -0.009 | -0.006 | -0.004 | 0.008 | -0.009 | 0.000 | -0.053 | -0.017 | -0.056 | -0.005 | -0.005 | -0.124 |
| monetary | -0.078 | 1.000 | 0.734 | 0.788 | 0.313 | -0.487 | 0.724 | 0.806 | 0.456 | 0.021 | 0.398 | 0.632 | 0.632 | 0.676 |
| unique_prods | -0.009 | 0.734 | 1.000 | 0.983 | 0.744 | -0.458 | 0.602 | 0.655 | 0.352 | -0.082 | 0.301 | 0.499 | 0.499 | 0.424 |
| qt_prods | -0.006 | 0.788 | 0.983 | 1.000 | 0.680 | -0.500 | 0.664 | 0.732 | 0.386 | -0.084 | 0.328 | 0.559 | 0.559 | 0.423 |
| avg_basket_size | -0.004 | 0.313 | 0.744 | 0.680 | 1.000 | -0.137 | 0.062 | 0.047 | 0.040 | -0.131 | 0.040 | 0.012 | 0.012 | 0.466 |
| recency | 0.008 | -0.487 | -0.458 | -0.500 | -0.137 | 1.000 | -0.563 | -0.564 | -0.254 | 0.096 | -0.205 | -0.431 | -0.431 | -0.133 |
| relationship_duration | -0.009 | 0.724 | 0.602 | 0.664 | 0.062 | -0.563 | 1.000 | 0.895 | 0.420 | 0.008 | 0.359 | 0.621 | 0.621 | 0.145 |
| purchase_count | 0.000 | 0.806 | 0.655 | 0.732 | 0.047 | -0.564 | 0.895 | 1.000 | 0.476 | 0.005 | 0.403 | 0.805 | 0.805 | 0.154 |
| returns_count | -0.053 | 0.456 | 0.352 | 0.386 | 0.040 | -0.254 | 0.420 | 0.476 | 1.000 | 0.059 | 0.989 | 0.363 | 0.363 | 0.190 |
| avg_unit_price | -0.017 | 0.021 | -0.082 | -0.084 | -0.131 | 0.096 | 0.008 | 0.005 | 0.059 | 1.000 | 0.063 | 0.004 | 0.004 | 0.031 |
| return_rate | -0.056 | 0.398 | 0.301 | 0.328 | 0.040 | -0.205 | 0.359 | 0.403 | 0.989 | 0.063 | 1.000 | 0.310 | 0.310 | 0.184 |
| avg_purchase_interval | -0.005 | 0.632 | 0.499 | 0.559 | 0.012 | -0.431 | 0.621 | 0.805 | 0.363 | 0.004 | 0.310 | 1.000 | 1.000 | 0.113 |
| frequency | -0.005 | 0.632 | 0.499 | 0.559 | 0.012 | -0.431 | 0.621 | 0.805 | 0.363 | 0.004 | 0.310 | 1.000 | 1.000 | 0.113 |
| avg_order_value | -0.124 | 0.676 | 0.424 | 0.423 | 0.466 | -0.133 | 0.145 | 0.154 | 0.190 | 0.031 | 0.184 | 0.113 | 0.113 | 1.000 |
| customer_id | monetary | unique_prods | qt_prods | avg_basket_size | recency | relationship_duration | purchase_count | returns_count | avg_unit_price | return_rate | avg_purchase_interval | frequency | avg_order_value | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 12347.0 | 4310.00 | 103 | 182 | 26.000000 | 2 | 365 | 7 | 0.0 | 2.644011 | 0.0 | 0.019178 | 0.019178 | 615.714286 |
| 1 | 12348.0 | 1437.24 | 21 | 27 | 6.750000 | 75 | 283 | 4 | 0.0 | 0.692963 | 0.0 | 0.014134 | 0.014134 | 359.310000 |
| 2 | 12349.0 | 1457.55 | 72 | 72 | 72.000000 | 18 | 0 | 1 | 0.0 | 4.237500 | 0.0 | 0.000000 | 0.000000 | 1457.550000 |
| 3 | 12350.0 | 294.40 | 16 | 16 | 16.000000 | 310 | 0 | 1 | 0.0 | 1.581250 | 0.0 | 0.000000 | 0.000000 | 294.400000 |
| 4 | 12352.0 | 1265.41 | 57 | 77 | 11.000000 | 36 | 260 | 7 | 63.0 | 4.075455 | 9.0 | 0.026923 | 0.026923 | 180.772857 |
| 5 | 12353.0 | 89.00 | 4 | 4 | 4.000000 | 204 | 0 | 1 | 0.0 | 6.075000 | 0.0 | 0.000000 | 0.000000 | 89.000000 |
| 6 | 12354.0 | 1079.40 | 58 | 58 | 58.000000 | 232 | 0 | 1 | 0.0 | 4.503793 | 0.0 | 0.000000 | 0.000000 | 1079.400000 |
| 7 | 12355.0 | 459.40 | 13 | 13 | 13.000000 | 214 | 0 | 1 | 0.0 | 4.203846 | 0.0 | 0.000000 | 0.000000 | 459.400000 |
| 8 | 12356.0 | 2487.43 | 52 | 58 | 19.333333 | 22 | 303 | 3 | 0.0 | 2.946034 | 0.0 | 0.009901 | 0.009901 | 829.143333 |
| 9 | 12357.0 | 6207.67 | 131 | 131 | 131.000000 | 33 | 0 | 1 | 0.0 | 3.348626 | 0.0 | 0.000000 | 0.000000 | 6207.670000 |
| customer_id | monetary | unique_prods | qt_prods | avg_basket_size | recency | relationship_duration | purchase_count | returns_count | avg_unit_price | return_rate | avg_purchase_interval | frequency | avg_order_value | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4318 | 18273.0 | 204.00 | 1 | 3 | 1.000000 | 2 | 255 | 3 | 0.0 | 2.550000 | 0.0 | 0.011765 | 0.011765 | 68.000000 |
| 4319 | 18274.0 | 0.00 | 11 | 11 | 11.000000 | 30 | 0 | 1 | 88.0 | 3.671818 | 88.0 | 0.000000 | 0.000000 | 0.000000 |
| 4320 | 18276.0 | 323.36 | 14 | 14 | 14.000000 | 43 | 0 | 1 | 2.0 | 2.482143 | 2.0 | 0.000000 | 0.000000 | 323.360000 |
| 4321 | 18277.0 | 97.63 | 8 | 8 | 8.000000 | 58 | 0 | 1 | 1.0 | 3.141250 | 1.0 | 0.000000 | 0.000000 | 97.630000 |
| 4322 | 18278.0 | 173.90 | 9 | 9 | 9.000000 | 73 | 0 | 1 | 0.0 | 3.283333 | 0.0 | 0.000000 | 0.000000 | 173.900000 |
| 4323 | 18280.0 | 180.60 | 10 | 10 | 10.000000 | 277 | 0 | 1 | 0.0 | 4.765000 | 0.0 | 0.000000 | 0.000000 | 180.600000 |
| 4324 | 18281.0 | 80.82 | 7 | 7 | 7.000000 | 180 | 0 | 1 | 0.0 | 5.622857 | 0.0 | 0.000000 | 0.000000 | 80.820000 |
| 4325 | 18282.0 | 176.60 | 12 | 12 | 6.000000 | 7 | 119 | 2 | 5.0 | 5.199167 | 2.5 | 0.016807 | 0.016807 | 88.300000 |
| 4326 | 18283.0 | 2088.93 | 262 | 754 | 47.125000 | 3 | 334 | 16 | 0.0 | 1.611379 | 0.0 | 0.047904 | 0.047904 | 130.558125 |
| 4327 | 18287.0 | 1837.28 | 59 | 70 | 23.333333 | 42 | 159 | 3 | 0.0 | 1.493571 | 0.0 | 0.018868 | 0.018868 | 612.426667 |